home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Power Tools for Macintosh
/
Power Tools for Macintosh (SoftBit)(1992).iso
/
Business
/
FileMaker Templates
/
AdMaster 2.0
/
Sales.FM
(
.txt
)
< prev
next >
Wrap
FileMaker Pro Database
|
1993-06-18
|
146KB
|
1,798 lines
Kneeds@
342-4838@
Women's@
KneeonsG
Jeepers@
BILL COMMENTS DATES
COMMISSION RATE
NEXT BILL DUE BY
PRODUCTION CHARGE LU
SALESPERSON INITIALS CALC
HBAM2001MAY84
Sales.FM:*
Casting
Chariots
Clinic
Films
Grace's
Happiness
Hollywood
Kneeons
Knighted
Lawrence
Lemons
Lotsa
Pantinene
Pasta
Restaurante
Spot/doty
Stone
Vales
Video
Women's
Bleed
Color
Eighth
Horiz
Non-bleed
Quarter
Advertising
Casting
Clothing
Lighting
Medical
Recreation
Restaurant
Sales
Allison
Allison
Dayna
Frank
Jeepers
Jerry
Jones
Longe
Sally
Smith
Smothers
45634
67455
Avenue
Canon
Drive
Hillhurst
Melrose
Monica
Santa
Street
Suite
Sunset
Varna
Wilshire
Angeles
Beverly
Burbank
Hills
Hills
Hollywood
North
10022
90024
90027
90028
90038
90048
90210
91502
91605
Andrea
Harry
Patty
Stephen
Advertising
Attire
Creative
Entertainment
Fashion
Fruit
Gardening
Health
Movies
Repair
Restaurant
Supplies
Video
Women
Approved
Camera
Cancelled
Problem
Produced
Proof
Ready
Received
Requested
Print
Two-pay
Visa/mc
Agency
Joe's
Ultimate
010231
123941
90016
Helterberg
Rocky
323-2342
662-1233
Johnny
Smith
Tommy
Agency
Barter
Angela
Approved
Change
Charge
Incorrect
Number
Phone
Production
Proof
Verbal
Waive
Jones
Kneeds
Simmons
Smith
Smothers
Thomas
Andrea
Harry
Jones
Kneeds
Patty
Simmons
Smith
Smothers
Stephen
Thomas
342-4838
453-1554
467-3000
471-2879
473-2181
508-2134
564-3592
643-0458
643-3247
658-8866
685-1108
743-3000
754-9890
213-3435
437-0893
574-9542
685-1108
Spoke
Lemons
Trade
Contract
Received
Casting
Chariots
Clinic
Films
Grace's
Happiness
Hollywood
Kneeons
Knighted
Lawrence
Lemons
Lotsa
Pantinene
Pasta
Restaurante
Spot/doty
Stone
Vales
Video
Women's
Discount
Agent
Chiropactor
Manager
Owner
President
Allison
Dayna
Frank
Jeepers
Jerry
Jones
Longe
Sally
Smith
Smothers
Allison
Dayna
Frank
Jones
Longe
Smothers
Automotive
Business
Entertainment
Medical
Personal
Advertising
Business
Entertainment
Fashion
Health
Recreation
Restauarant
Attire
Creative
Entertainment
Health
Movies
Repair
Restaurant
Video
Casting
Chariots
Clinic
Films
Grace's
Happiness
Hollywood
Kneeons
Kneeons
Knighted
Lawrence
Lemons
Lotsa
Pantinene
Pasta
Restaurante
Spot/doty
Stone
Vales
Video
Women's
Bottom
Center
Column
Facing
Furniture
Kneeons
Knighted
Right
Section
Upper
Allison
Dayna
Frank
Jeepers
Jerry
Jones
Longe
Sally
Smith
Smothers
Allison
Dayna
Frank
Jones
Longe
Smothers
Pro 2.0F!
Pro 2.0I
Main Dictionary
6/17/93
AD NUMBER
ADDITIONAL LISTINGS ACTUAL
ADDITIONAL LISTINGS DESIRED
ADDRESS
AGENCY ADDRESS
AGENCY CONTACT
AGENCY GROSS COST
AGENCY NAME
AGENCY NET COST
AGENCY PHONE
BALANCE OUTSTANDING
BALANCE OUTSTANDING TOTAL
BILL COMMENTS
NENCY GROSS COST
AGENCY NAME
AGENCY NET COST
AGENCY PHONE
BALANCE OUTSTANDING
BALANCE OUTSTANDING TOTAL
BILL COMMENTS
BILL COMMENTS DATES
BILL SIZE DEFAULT
BONUS EARNED
BONUS EARNED 2ND SP
BONUS EARNED TOTAL
BOOK ID
CATEGORY ACTUAL
CATEGORY DESIRED
COMMENT FOR BILL
COMMISSION ACTUAL
COMMISSION ACTUAL 2ND SP
COMMISSION ACTUAL 2ND SP SUM
COMMISSION ACTUAL SUM
COMMISSION ADJUSTMENT
COMMISSION ADJUSTMENT 2ND SP
COMMISSION POTENTIAL
COMMISSION POTENTIAL 2ND SP
!COMMISSION POTENTIAL 2NS SP TOTAL
COMMISSION POTENTIAL TOTAL
COMMISSION RATE
COMMISSION RATE 2ND SP
COMPANY
COMPANY COUNT
COMPANY DISPLAY
COMPANY LU
COMPENSATION TOT
COMPENSATION TOT TOTAL
COMPENSATION TOTAL
COMPENSATION TOTAL TOTAL
CONTACT FIRST
CONTACT FULL
CONTACT LAST
CONTACT TITLE
CONTRACT STATUS
a DATE SOLD
DATE SOLD FIRST
DATE SOLD LAST
DISCOUNT FLAG
DISCOUNT TYPE
DUE DATE CALC
LAST BILL AMT
LAST BILL DUE BY
LAST SENT ON
NEXT BILL AMOUNT
NEXT BILL DUE BY
NUMBER OF COLORS
OTHER DISCOUNT
OTHER DISCOUNT COMMENT
PAID LAST BILL
PAID PERCENT OF SALE
PAID PERCENT OF SALE TOTAL
PAYMENT PLAN
PAYMENT RCVD DATE LAST
PAYMENTS RCVD TOTAL
PAYMENTS RCVD TOTAL TOTAL
PAYMENTS RECEIVED
PAYMENTS RECEIVED CHECK NO
PAYMENTS RECEIVED DATES
PHONE
PLACEMENT DESIRED
PLACEMENT PAGE NUM
PRODUCTION BEGAN
PRODUCTION CHARGE ACTUAL
PRODUCTION CHARGE ACTUAL TOTAL
PRODUCTION CHARGE LU
PRODUCTION COST
PRODUCTION COST TOTAL
PRODUCTION LOSS
PRODUCTION LOSS TOTAL
PRODUCTION NOTES
PRODUCTION NOTES DATE
PRODUCTION STATUS
PROFIT
PROFIT PERC OF SALE
PROFIT PERC OF SALE TOTAL
PROFIT TOTAL
REBILLED ON
RECEIVED TO DATE
RECEIVED TO DATE TOTAL
RETURN MATERIALS
SALEPERSON #
SALESPERSON
SALESPERSON # 2ND SP
SALESPERSON 2ND SP
SALESPERSON DISPLAY
SALESPERSON DISPLAY 2ND SP
SALESPERSON INITIALS CALC
SALESPERSON LU
SALESPERSON LU 2ND SP
SECTION
SIZE NUMBER
SIZE NUMBER TOTAL
SPACE CHARGE
SPACE CHARGE CALC
SPACE CHARGE COUNT
SPACE CHARGE LOOKUP
SPACE CHARGE RCVD TOTAL
SPACE CHG RCVD
SPACE CHG RCVD COUNT
SPACE CREDIT
SPACE CREDIT TOTAL
SPACE OUTSTANDING
STATE
SUBTOTAL
SUBTOTAL COUNT
TAB DISPLAY
TOTAL DISCOUNT
TOTAL DISCOUNT TOTAL
TOTAL SALE
TOTAL SALE COUNT
Company LUB
A Ad NumberB
A Date SoldB
SizeB
Tab (bleed)
Tab (non-bleed)
Full page color
Full page B&W
Half page (vert)
Half page (horiz)
Quarter page (vert)
Quarter page (horiz)
Eighth page
Category DesiredB
(none)
Space ChargeB
WIF 93sK
can't find
Production Charge ActualB
ChargesnK
can't findM
Total SaleB
SubTotal - Total Discount
SalespersonB
Salespeople.FM
AddressB
Leads.FMt
CityB
Leads.FMt
StateB
Leads.FMt
Leads.FMt
Contact FirstB
Leads.FMt
Additional Listings DesiredB
Number of Colors
1 spot
2 spot
Four Color
Production StatusB
No Input
Camera Ready - not received
Camera Ready - received - OK
Camera Ready - received - Problem
Camera Ready - approved
To be Produced - not received
To be Produced - received - OK
To be Produced - rece
ived - Problem
To be Produced - in production
To be Produced - out to proof
To be Produced - approved
Old Ad - requested - OK
Old Ad - requested - Problem
Old Ad - approved
On Hold
Cancelled C
No Input
Payment PlanB
Two-Pay
Visa/MC
Agency NameB
Agency AddressB
Agency PhoneB
Agency ContactB
Agency Gross CostB
Agency Net CostB
discount typeB
5% Full
15% Agency
Barter
Production notesB
Production notes dateB
SubTotalB
A'Space Charge + Production Charge Actual
Other DiscountB
Total DiscountB
((Space Charge*((If (Position (discount type,"5% Full", 1), .05, 0)+If (Position (discount type,"15% Agency", 1), .15, 0)))+Other Discount))
5% Full
15% Agency
333333
Contact LastB
Leads.FMtK
can't find
Balance OutstandingB
Total Sale-Received to Date
Payments ReceivedB
Payments Received DatesB
Received to DateB
Sum (Payments Received)
Comment for BillB
Charges
can't find
Next Bill AmountB
WIF 93sK
can't find
Next Bill due byB
WIF 93sK
can't find
contact fullB
Leads.FMtK
can't find
phoneB
Leads.FMtK
can't find
Leads.FMtK
can't find
Bill CommentsB
Bill comments datesB
Bill Size DefaultB
AxIf (Payment Plan = "Two-Pay" and Balance Outstanding
( .6 * Total Sale), .5 * Balance Outstanding, Balance Outstanding)
Two-Pay
333333
Last Bill amtB
Last Sent onB
Rebilled onB
Last Bill Due ByB
Other Discount CommentB
Due Date CalcB
Tody+30
Contract StatusB
Rcvd Contract
Not Received
Not Received
CompanyB
Leads.FM K
Something's Wrong
Discount FlagB
A#IF (total discount>0,"Discount","")
Discount'
Contact TitleB
Leads.FMtK
can't find
Space Charge CalcB
Space Charge Lookup
Space Charge LookupB
Charges.FM<K
can't find
Company CountB
Return materialsB
Production CostB
Production BeganB
Payments Received Check NoB
Space Charge CountB
Size NumberB
Charges.FM<K
can't find
Size Number TOTALB
Space Chg RcvdB
A?IF(Received to Date<Space Credit,Received to Date,Space Credit)
Bonus EarnedB
12.50
51.50
Bonus Earned TOTALB
Total Discount TOTALB
Space Charge Rcvd TOTALB
Commission RateB
commission adjustmentB
Commission actualB
A9Commission Rate *( Space Chg Rcvd)+ commission adjustment
commission actual SUMB
Space CreditB
A?IF(Space Charge-Total Discount>0,Space Charge-Total Discount,0)
space Credit TotalB
Balance Outstanding TOTALB
Production Cost TOTALB
production lossB
A*Production Cost - Production Charge Actual
Production loss TOTALB
production charge actual TOTALB
Book IDB
A,PAR 92
PAR 93
WIF 93
PAR 94
SONY 94
CBS 94
Fall '93
Production Charge LUB
Charges.FM<K
can't find
Salesperson Initials CalcB
APLeft (Salesperson, 1) & Middle (Salesperson,1+
Position (Salesperson, " ", 2),1)
Commission PotentialB
A-(Space Credit-Space Chg Rcvd)*Commission Rate
commission potential TOTALB
SubTotal CountB
received to date TOTALB
Total Sale CountB
Space Chg Rcvd CountB
Salesperson LUB
Leads.FM
can't find
Salesperson 2nd SPB
Salespeople.FM
can't find
Commission Rate 2nd SPB
commission actual 2nd SPB
AF(Commission Rate 2nd SP * Space Chg Rcvd)+Commission adjustment 2nd SP
commission actual 2nd SP SUMB
:(_N^Nu
Salesperson LU 2nd SPB
Paid percent of saleB
AYIF ((Space Charge-Total Discount)>0,(Compensation total)/(Space Charge-Total Discount),0)
paid percent of sale TOTALB
Date Sold FirstB
Date Sold LastB
SectionB
Saleperson #B
Salespeople.FM
AllisonE
HillsC
323-2342@
Kneeds@
342-4838@
Women's@
KneeonsG
Jeepers@
BILL COMMENTS DATES
COMMISSION RATE
NEXT BILL DUE BY
PRODUCTION CHARGE LU
SALESPERSON INITIALS CALC
Commission adjustment 2nd SPB
SALESPERSON # 2nd SPB
Salespeople.FM
TAB displayB
A IF (Left(size,3)="Tab","Tab","")
Compensation totalB
A Commission actual + Bonus Earned
Compensation total TOTALB
Category actualB
Additional Listings ActualB
Company DisplayB
Company
Bonus Earned 2nd SPB
Commission Potential 2nd SPB
A4(Space Credit-Space Chg Rcvd)*Commission Rate 2nd SP
Space OutstandingB
AD(IF ((Space Chg Rcvd<Space Credit),Space Credit - Space Chg Rcvd,0))
Placement DesiredB
Salesperson DisplayB
Salesperson
Placement Page numB
Salesperson Display 2ND SPB
Salesperson 2nd SP
Paid last billB
A#Payment Rcvd Date last>Last Sent on
Payment Rcvd Date lastB
last(Payments Received Dates)
TodyB
A!commission potential 2ns sp TOTALB
Payments Rcvd TotalB
Sum (Payments Received)
Compensation totB
AKCommission actual+commission actual 2nd SP+Bonus Earned+Bonus Earned 2nd SP
ProfitB
A4Payments Rcvd Total-Production Cost-Compensation tot
Profit Perc of SaleB
Profit/Payments Rcvd Total
Payments Rcvd Total TOTALB
Compensation tot TOTALB
Profit TOTALB
Profit Perc of Sale TOTALB
Sold By Company
Sold By Salesperson
Sold By desired cat
Production Overview
Production Detail
Accounts Summary
A Statement
A#Master Sales Splits For Salespeople
Categories Actual
Sales
Agency
Billing
Commission
Production
Rebill Statement
Sold By actual cat
A Placement
Sold By Salesperson
Mailing Labels
Production Problems
Categories Desired
OVERDUE ACCOUNTS
A Need Bill
Comm stmt Sold
Comm stmt split Sold
A Ad Profit
Sold By CompanyB
YesfH
Company
Sold ads as of //
page ##
ads sold.
Salesperson
E Date Sold
Sales
Sold By Salesperson
YesfH
Company
Sold ads as of //
page ##
has sold
Sales for
ads.
contact
phone
Sold By desired cat
YesfH
Company
E%Sold ads by Desired Category as of //
E'Sold WIF by category as of //
page ##
E ads for
Salesperson
Desired Category:
E Date Sold
Production OverviewB
YesfH
YesfH
Company
Production Status
Production Overview as of //
Prod.
Began
E Prod
ads listed.
Charge
Sales
Production
Production Detail
YesfH
YesfH
YesfH
Company
E$Production Report as of // by Status
Prod Began
Total Ads:
E Prod Cost
Prod.
Charge
Salesperson
Accounts SummaryB
YesfH
YesfH
YesfH
YesfH
Company
contact name
Total Sale
Balance
Outst
OUSTANDING ACCOUNTS AS OF //
Balance Outstanding Total
phone
Sales
ads listed.
Last Bill Sent
Last pymt Rcvd
'A StatementB
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
A<Statement of Account
for Advertisement in 1994 Master Guide
Contract #:
Salesperson:
Size:
Payment Plan:
Amount Due Now
Comments
Due By
E3Thank you for your support of the 1994 Master Guide
Bill To:
Statement Date:
Current Charges
Ad Info:
Received
Total Sale
Production
Space
Balance
Outstanding
AWPlease remit to:
Praxis Computing
1911 Camino Costa
Suite #415
Redondo Beach, CA 90277
.A#Master Sales Splits For SalespeopleB
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
E Date
Company
Prod/
Color
E Comission
Net Sale
Discount
Split Sales, //
Advertiser
Totals
Outstanding
Space$
Net Sale
Space Paid
E Comm
// - ##
Categories ActualB
Company
Section
Category Actual
Additional Listings
E%Sections & Actual Categories as of //
Sales
E Placement
SalesB
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
Desired
Category
Desired
Additional
Listings
Colors
Production
Status
SaleS
Company
Contract
Production
Space
SubTotal
Total Sale
Total Discount
Payment
Other Discount
Charges
Payment Plan
E Date Sold
Address
Contact
phone
AD Info
E Discounts
Amount
Description
Agency
Salesperson
Defaults
Billing
Commission
Production
E Placement
command
center
AgencyB
Agency Name
Address
Phone
Contact
Agency
Sales
BillingB
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
Total Sale
Outstanding
Payment Plan
Received to Date
Payment
bill for
due by
Due by
E Next Bill
Comment
for Bill
Check #
Advertiser Payments
Company
BILLING
E LAST BILL
Rebilled
COMMENTS
Defaults
E Send Bill
Rebill
Sales
Comment
E Date Sold
CommissionB
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
Space Credit
Space Paid
Salesperson #1
Company
ComMission
Salesperson
Bonus
Commission
Adjustment
Commission
Salesperson #2
Salesperson
Bonus
Commission
Adjustment
Commission
Add. Comm.
on full collection
Add. Comm.
on full collection
Space Charge
Total Discount
Space
Outstanding
Sales
ProductionB
YesfH
YesfH
YesfH
Production Detail
Colors
Production Notes
Return
materials?
Production
Production
Began
Production
Production Status
Desired
Category
Desired
Additional
Listings
Company
Desired
Placement
Production
Charge
Salesperson
Sales
Rebill StatementB
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
A<Statement of Account
for Advertisement in 1994 Master Guide
Contract #:
Salesperson:
Size:
Payment Plan:
Amount Due Now
Comments
Due By
E3Thank you for your support of the 1994 Master Guide
Bill To:
Statement Date:
Current Charges
Ad Info:
Received
Total Sale
Production
Space
Balance
Outstanding
AWPlease remit to:
Praxis Computing
1911 Camino Costa
Suite #415
Redondo Beach, CA 90277
SECOND NOTICE
Sold By actual cat
YesfH
Company
E$Sold ads by Actual Category as of //
page ##
E ads for
Salesperson
Desired Category:
E Date Sold
Category Desired
BA PlacementB
YesfH
Production Detail
Colors
E PLACEMENT
Desired
Category
Desired
Additional
Listings
Company
Desired
Placement
Salesperson
Sales
Actual
Category
Actual
Additional
Listings
Actual
Page #
Section
Sold By SalespersonB
YesfH
Company
Sold ads as of //
page ##
ads sold.
Salesperson
E Date Sold
Sales
Mailing LabelsB
Sales
Production ProblemsB
YesfH
Company
Production Status
Production Problems as of //
Prod.
Began
E Prod Cost
ads listed.
Prod.
Charge
Sales
Production
Categories DesiredB
Company
Category Desired
Actual Additional Listings
E&Sections & Desired Categories as of //
Sales
Category Actual
E Placement
OVERDUE ACCOUNTSB
YesfH
YesfH
YesfH
YesfH
YesfH
Company
contact name
Total Sale
Balance
Outst
OVERDUE ACCOUNTS AS OF //
Balance Outstanding Total
phone
Sales
ads listed.
Last bill amount
Due by
Rebilled
Rebill All
HA Need BillB
YesfH
YesfH
YesfH
YesfH
Company
contact name
Total Sale
Balance
Outst
ACCOUNTS NEEDING BILLS AS OF //
Balance Outstanding Total
phone
Sales
ads listed.
Last Bill Sent
Last pymt Rcvd
Bill All
Comm stmt Sold
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
Company
Ads for Comission as of //
page ##
has sold
Sales for
ads.
Discount
Space
Space
Credit
Space Chg
Comm
Comm
Actual
Add. comm on full Collect.
TOTAL
Comm stmt split Sold
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
YesfH
Company
E Split Ads for Comission as of //
page ##
E has split
Sales for
ads.
E Comission
Discount
Advertiser
Outstanding
Space
Space Paid
E Comm
Space
Credit
Space Chg
Comm
Comm
Actual
Add. comm on full Collect.
TOTAL
KA Ad ProfitB
YesfH
Company
Ad Profit as of //
page ##
ads sold.
Sales
Payment
E Prod
Salesp Comp
Profit
% Profit
Lawrence of HollywoodB
1/17/93D
Full page colorE
Auto SalesF
712.5J
Frank JonesQ
123 Santa Monica Blvd.R HollywoodS
90038Z
Harry]
Auto Repair^
None_
Camera Ready - approved`
Fulla
nonei
5% Fullr
37.5~
Kneeds
712.50
6/1/93
712.5
Harry Kneeds
(213)643-3247
(213)685-1108
Not Received
Lawrence of Hollywood
Discount
Ad Manager
712.5
106.875
712.5
Fall '93
Frank Jones
Automotive
106.875
Auto Repair
Lawrence of Hollywood
Frank Jones
06/01/93
712.5
106.875
605.625
Casting for CastingB
2/17/93D
Full page colorE
CastingF
Jerry JeepersQ
9561 Sunset Blvd.
Suite 100R HollywoodS
90038Z
Andrea^
None_#To be Produced - received - Problem`
Two-Paya
nonej
Phone Number Incorrectk
2/12/93r
Smothers
07/17/93
Andrea Smothers
(213)453-1554
2/18/93
3/18/93
07/17/93
Not Received
Casting for Casting
d President
1/3/93
Fall '93
112.5
Jerry Jeepers
Entertainment
Entertainment
Casting for Casting
Jerry Jeepers
6/17/93
A Drew ArtsB
1/17/93D
Full page colorE
637.5J
Jerry Jeepers
532 Wilshire Blvd.
Suite 230R
Beverly HillsS
90210Z
Biff]
Creative Supplies^
None_
Old Ad - requested - OK`
Visa/MCa
Joe's Ad Agencyb 1760 Rocky Road Dr.
LA, CA 90016e
(310) 662-1233f
Tommy Smithi
15% Agencyr
112.5~
Jones
137.5
1/18/93
Biff Jones
(213)754-9890
(213)685-1108
137.5
137.50
5/5/93
6/5/93
Rcvd Contract
b Drew Arts
Discount
Chiropactor
637.5
Fall '93
20.625
Jerry Jeepers
.117647058823529412
Entertainment
Drew Arts
137.5
Jerry Jeepers
01/18/93
Chariots of StoneB
3/17/93D
Quarter page (vert)E
(none)F
Jerry JeepersQ
865 Melrose Avenue #107R HollywoodS
90038^
Four Color_
On Hold`
Two-Paya
noner
3/17/83
4/17/93
(213)658-8866
(213)213-3435
Rcvd Contract
Chariots of Stone
Owner
Fall '93
Jerry Jeepers
Allison Smothers
Entertainment
Entertainment
Chariots of Stone
Not in Furniture Section
Jerry Jeepers
Allison Smothers
04/17/93
The ParkB
1/11/93D
Half page (vert)E
RecreationF
Allison SmothersQ
862 Park AvenueR
New York CityS
10022] Gardening
1 spot_
Cancelled `
Fulla
nonei
5% Fullr
(212)467-3000
N(Spoke with Tom - said will pay this week
3/25/93
1/1/93
3/11/93
2/11/93
Rcvd Contract
The Park
Discount
Fall '93
71.25
Allison Smothers
Entertainment
Recreation
The Park
Center Column
Allison Smothers
Grace's LemonsB
5/2/93D
Eighth pageE
Frank JonesQ
895 N. Canon DriveR
Beverly HillsS
90210]
Fruit, Restaurant^
None_#To be Produced - received - Problem`
Two-Paya
nonei
Barterr
(213)471-2879
(213)685-1108
Trade for Lemons
Rcvd Contract
Grace's Lemons
Discount
Agent
1/3/93
Fall '93
Frank Jones
Restauarant
Restaurant
Grace's Lemons
Frank Jones
Knighted KneeonsB
1/17/93D
Tab (bleed)E
LightingF
1000H
1000J
Jerry JeepersQ
45634 Varna AvenueR
North HollywoodS
91605Z
Patty]
Advertising^
Four Color_
To be Produced - out to proof`
Two-Paya
noner
1000z
Smith
3/3/93
Patty Smith
(818)564-3592
4/1/93
5/1/93
Rcvd Contract
Knighted Kneeons
1/3/93
Fall '93
Jerry Jeepers
Business
Business
Knighted Kneeons
Jerry Jeepers
03/03/93
Restaurante PantineneB
6/1/93D
Tab (non-bleed)E
(none)F
1100J
Jerry JeepersQ
67455 Melrose Blvd.R HollywoodS
90038^
Four Color_
To be Produced - out to proof`
Visa/MCa
noner
1100z
(213)685-1108
(213)685-1108
5/5/93
7/5/93
6/5/93
Rcvd Contract
Restaurante Pantinene
Adv. Manager
3/1/93
Fall '93
Jerry Jeepers
Take Out
Restaurante Pantinene
Jerry Jeepers
Sler Vales, Inc.B
3/17/93D
Quarter page (vert)E
AdvertisingF
Dayna LongeQ
960 N. Lake StreetR
BurbankS
91502Z
Tom] Creative ^
1 spot_
Camera Ready - approved`
Fulla
nonei
5% Fullr
2/1/93
Tom Fred
(818)342-4838
(818) 574-9542
Rcvd Contract
Sler Vales, Inc.
Discount
42.75
Fall '93
Dayna Longe
Dayna Longe
Entertainment
42.75
Advertising
Creative
Sler Vales, Inc.
Facing page to Knighted Kneeons
Dayna Longe
Dayna Longe
02/01/93
116.25
168.75
.592105263157894737
A Spot/DotyB
6/6/93D
Quarter page (horiz)E
ClothingF
Allison SmothersQ
290 Wilshire BlvdR
Los AngelesS
90024Z
Fashion, Attire^
Four Color_
Camera Ready - not received`
Pay on Printa
noner
Thomas
07/17/93
Joe Thomas
(310) 508-2134
5/5/93
6/25/93
6/5/93
07/17/93
Not Received
b Spot/Doty
Fall '93
Allison Smothers
Personal
Fashion
Attire
Spot/Doty
Allison Smothers
6/17/93
Women's Happiness ClinicB
2/6/93D
Full page colorE
MedicalF
Dayna LongeQ 31 W. 3rdR
Los AngelesS
90048Z
Jeff]
Health, Women^
Four Color_
Old Ad - requested - Problem`
Two-Paya
nonej
Change area code 213->310k
2/1/93r
Thomas
07/17/93
Jeff Thomas
(213) 743-3000
5/5/93
6/5/93
07/17/93
Rcvd Contract
Women's Happiness Clinic
Fall '93
112.5
Dayna Longe
Medical
Health
Women's Happiness Clinic
Bottom Left
Dayna Longe
6/17/93
Pasta LotsaB
2/6/93D
Half page (horiz)E
RestaurantF
Sally SmithQ
0875 Hillhurst AvenueR
Los AngelesS
90027Z
Stephen]
Health^
None_
To be Produced - approved`
Fulla
nonei
5% Fullj!Proof Approved by Angela (verbal)k
6/1/93r
Smothers
07/17/93
Stephen Smothers
(213)643-0458
5/5/93
6/5/93
07/17/93
Rcvd Contract
Pasta Lotsa
Discount
3/1/93
Fall '93
71.25
Sally Smith
Take Out
Health
Pasta Lotsa
Sally Smith
6/17/93
Films on Film & VideoB
1/17/93D
Full page B&WE
FilmF
Frank JonesQ
834 Sunset Blvd.R Hollywood
90028Z
Video, Entertainment, Movies^
2 spot_#To be Produced - received - Problem`
Visa/MCa
Ultimate Adsb#123941 Helterberg St.
NY, NY 010231e
(315)323-2342f
Johnnyi
15% Agencyj"Waive Production Charge as per Tomk
6/1/93r
Simmons
07/17/93
Don Simmons
(213) 473-2181
(213) 437-0893
5/5/93
6/5/93
07/17/93
Not Received
Films on Film & Video
Discount
d President
5/1/93
Fall '93
Frank Jones
Frank Jones
Entertainment
Video, Entertainment, Movies
Films on Film & Video
Upper Right
Frank Jones
Frank Jones
6/17/93
Problem
Bill All
Rebill All
Need Bill Find
Sold from Leads
Ad Cost Defaults
Next Bill Defaults
Bill This One
Rebill This One
Rebill This Set
Bill This Set
Command Center
MODULES:
leads
sales
salespeople
REPORTS:
sold by company
sold by salesperson
section/actual category
section/desired category
Need Bills
outstanding accounts
overdue accounts
production overview
production problems
mailing labels
SPECIAL
calculate comissions
comission sales reports
Ad Profits
salesperson sold detail
splits by salesperson
categories detail
production detail
desired categories detail
actual categories detail
Print these Records
Print Two of This Record
Resore Page Setup
Print All Up
Rebill This Set
Rebill set pt2
Main Exports
Split Exports
startup
Print these Records
Print Two of This Record
Bill This One
Next Bill Defaults
Ad Cost Defaults
Resore Page Setup
sold by company
Print All Up
salesperson sold detail
categories detail
Rebill This One
Rebill This Set
Rebill set pt2
splits by salesperson
WIF 93
Main Exports
tempmain temp!
lookdrct.FMct Lookupsy:
lookdrct.FMct Lookups
Split Exports
tempmain temp!
looksplit.FM Lookupssy:
looksplit.FM Lookupss
calculate comissions
Salespeople.FM
Specify:
lookdrct.FMcalculat
looksplit.FMalculat
sales
salespeople
Salespeople.FMP
leads
Leads.FM
Sold from Leads
MODULES:
REPORTS:
SPECIAL
desired categories detail
actual categories detail
section/actual category
production overview
production detail
sold by salesperson
outstanding accounts
mailing labels
production problems
Problem
section/desired category
overdue accounts
Rebill All
Rebill This Set
Need Bill Find
<=6/5/93
Need Bills
Bill All
Bill This Set
comission sales reports
Ad Profits
Command Center
AdMaster.FM
startup
Test Group
Helvetica
Geneva
Chicago
New York
Palatino
Avant Garde
N Helvetica Narrow
Times
User Dictionary